Release 10.1A: OpenEdge Getting Started:
Core Business Services

Reporting on a central archive database

By using an audit archive utility, you can source audit data from multiple short-term application databases and aggregate it into a central audit archive database purposed for long-term storage and security. The originating database is identified by the designated database GUID field _db-guid, which uniquely identifies all Release 10.1A databases. The archive utility also copies records in the _db-detail table, which contains a record for each database GUID, and provides additional information such as a description of the database for reporting purposes as well as security information.

Any reports on the audit data should join to the _db-detail table using the _db-guid to show more detail about the database, such as the database description, if available.